CREATE TABLE log_settings
(
	param_name	VARCHAR2(32),
	param_value	VARCHAR2(128),
	comments		VARCHAR2(1024),
	CONSTRAINT log_settings_pk PRIMARY KEY(param_name)
		USING INDEX
		(CREATE UNIQUE INDEX log_settings_pk_idx ON log_settings(param_name ASC))
);

INSERT INTO log_settings(param_name, param_value, comments)
	VALUES('TRACE_LEVEL', 'WARNING', 'Current log trace level');

INSERT INTO log_settings(param_name, param_value, comments)
	VALUES('HISTORY_DEPTH', '30', 'For how many days to keep records');

COMMIT;
